You can't open the SmartSpreadsheet Spreadsheet outside Qlikview. So if you don't have an existing QVW you must create one.
In order to store the functions and procedures of the SmartSpreadsheet Spreadsheet the
QlikView document must have at least the following variables. vSpreadData &
vSpreadCalc.
In the Qlikview Document toolbar you will find the Settings button.Choose "Variable
Overview" and Add the above Variables. See the picture below.
The SmartSpreadsheet Spreadsheet working only in web view. So you must turn on the web
interface.
In the Qlikview Document toolbar you will find the View button.Choose "Turn on/off
Webview". See the picture below.
When you are in web view right click in the sheet and choose New Sheet Object andthen
Extension Objects.
Then drag the cross beside the SmartSpreadsheetSheet and drop it to the sheet. See the
picture below ©
· How to use SmartSpreadsheet
· SmartSpreadsheet Spreadsheet
functionality
· SmartSpreadsheet Spreadsheet text
formatting
· SmartSpreadsheet Spreadsheet sheet
formatting· Saving
You can use the SmartSpreadsheet Spreadsheet in the following ways.
You can have true data integrity by Uploading your excel spreadsheet into Qlik and use the Qlik functionality.
Use the File drop down menu and Upload you excel spreadsheet either Overwriting the old one or Appending new Sheets on it.
In the picture below you can see the File drop down menu.
You can use the fields of your Qlik document as Dimensions or Expressions like in any other
Qlikview Object (Tables, Pivot etc).
Right click on the SmartSpreadsheet spreadsheet and choose properties. Then add the desired
dimensions and expressions.
In the picture below you can see the "Properties" menu.
After uploading your Excel Spreadsheet into the SmartSpreadsheet you can add a new sheet and use the Excel data in combination with the fields of your Qlik document Right click on the SmartSpreadsheet spreadsheet
After you creating the SmartSpreadsheet Spreadsheet you can use the Spreadsheet Formula
Functionsand the SmartSpreadsheet Formula Functions to manipulate your data.
You can use the Spreadsheet Formula Functions by begin writing in the appropriate cell the
"=" character and then the first letters of the desired function.
An autocomplete window will helps you syntax the formula.
Or you can use the SmartSpreadsheet Formula Functions by clicking the fx button above the
letter captions of the spreadsheet.
In the picture below you can see the fx button.
You can format text using the Spreadsheet Home menu.
It has the most favorite text format functions divided into four categories.
· Font
· Alignment
· Merge
· Numbers
In the picture below you can see the Home menu.
You can delete, insert or format cells, columns, rows or entire sheets using the Spreadsheet
Additional menu.
You cal also Sort your data or use the Auto Filter Row Function.
The functions of this menu are divided into two categories.
· Cells
· Short
and Filter
In the pictures below you can see the Additional menu and its sub menus.
Cells --> Delete
Cells --> Format
Short and Filter
Before Saving your Qlikview Document you must Save the In the File menu use the Save SmartSpreadsheet button. Then you can save your Qlikview Document safely. Spreadsheet.
The printing procedure is simple also. Use the
Then choose from the Print Sheet
In the picture below you can see the
File drop down menu and select
Preferences the desired values and press the OK button.
Print Sheet Preferences window.
In the File menu you can use Download or Download Values buttons to export you
SmartSpreadsheet Spreadsheet.
· Download : You can export the entire Spreadsheet with the Formulas.
· Download Values : You can export the entire Spreadsheet without Formulas.
In the picture below you can see the File drop down menu.